package com.ruoyi.reportsnhnt.mapper;

import com.ruoyi.reportsnhnt.domain.ReportSnhntKyqdBaDetail;
import com.ruoyi.reportsnhnt.domain.vo.ReportSnhntKyqdBaDetailVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 水泥混凝土抗压强度试验检测记录详情Mapper接口
 *
 * @author zxs
 * @date 2024-06-21
 */
public interface ReportSnhntKyqdBaDetailMapper extends BaseMapperPlus<ReportSnhntKyqdBaDetailMapper, ReportSnhntKyqdBaDetail, ReportSnhntKyqdBaDetailVo> {

    @Select("select kyqd.* from report_snhnt_kyqd_ba_detail kyqd,syrw_ref_report_excel ref,syrw_bi_excel_type bi where ref.excel_type_id = bi.excel_type_id and kyqd.excel_id = ref.excel_id " +
        " and ref.report_id = (select report_id from syrw_ref_report_excel where excel_id = #{excelId}) and bi.label ='snhntkyqd' ")
    List<ReportSnhntKyqdBaDetail> selectDetailListByExcelId(Long excelId);

}
